******************** time ********************
2024-09-29 13:35:51


******************** query ********************
PRINT @Name
PRINT @Status
PRINT @Active
PRINT @Id
PRINT @UserId
PRINT @FPId

UPDATE __Android__Target__ SET [Name] = @Name, [Status] = @Status, [Active] = @Active WHERE [Id] = @Id AND [UserId] = @UserId AND [FPId] = @FPId


******************** message ********************
Must declare the scalar variable "@Name".
Must declare the scalar variable "@Status".
Must declare the scalar variable "@Active".
Must declare the scalar variable "@Id".
Must declare the scalar variable "@UserId".
Must declare the scalar variable "@FPId".
Must declare the scalar variable "@Name".


******************** StackTrace ********************
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) in /_/Dapper/SqlMapper.cs:line 1066
   at Dapper.SqlMapper.QueryRowImpl[T](IDbConnection cnn, Row row, CommandDefinition& command, Type effectiveType) in /_/Dapper/SqlMapper.cs:line 1187
   at Dapper.SqlMapper.QueryFirstOrDefault[T](IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) in /_/Dapper/SqlMapper.cs:line 774
   at BaseServices.SysDataAccessLayer.ExecuteQueryFirstOrDefault[T](IDbConnection& dbConnection, String query, Int32& errIndex, Object param, IDbTransaction dbTransaction) in C:\dev\projects\tadbir-applications-webservice\BaseServices\Services\Implementation\SysDataAccessLayer.cs:line 2190
   at BaseServices.Services.Implementation.TargetRepository.UpdateTarget(APIHeader header, Int32 id, Target target) in C:\dev\projects\tadbir-applications-webservice\BaseServices\Services\Implementation\TargetRepository.cs:line 108


